Cannot find Confirm Record Changes in Options under View menu due to moved.
Cause:
The 'Options...' command has been moved to the 'Tools' menu, and the 'Confirm Record Changes' option has been renamed 'Record Changes' and moved to the 'Confirm' group of the 'Edit/Find' tab.
Solution:
To enable the confirmation of record changes in Access 7.0, use the 'Options...' command under the 'Tools' menu, and select the 'Record Changes' check box of the 'Edit/Find' tab.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click the 'Edit/Find' tab.
3) Select the 'Record Changes' check box in the 'Confirm' group.
NOTE: Checking 'Record Changes' sets the confirmation of record changes as the default for all new tables.
Record Changes
4) Click 'OK'. (The Options dialog box closes.)